USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_RESPOSTA_LISTAR')
	DROP PROCEDURE P_RESPOSTA_LISTAR
GO
CREATE PROCEDURE P_RESPOSTA_LISTAR(
	@IDPERGUNTA	INTEGER)
AS BEGIN
	SELECT
		IDPERGUNTA,
		IDRESPOSTA,
		NRORESPOSTA,
		DESCRESPOSTA,
		ATIVO,
		USUARIOINCLUSAO,
		DTHRINCLUSAO,
		USUARIOALTERACAO,
		DTHRALTERACAO
	FROM
		RESPOSTA
	WHERE
		IDPERGUNTA = @IDPERGUNTA
END